/**
 * 
 */
package com.feib.stms.dao;

import com.feib.stms.model.AuditEntity;
import com.feib.stms.model.PreDesignatedAccount;

/**
 * @author Karl Chen
 *
 */
public interface PreDesignatedAccountDao {

	/**
	 * 根據分公司代號查詢約定帳號
	 * @param securitiesNo
	 * @param bankBracnchNo TODO
	 * @return
	 */
	public PreDesignatedAccount getPreDesignatedAccountBySecuritiesNo(String securitiesNo, String bankBracnchNo);
	
	/**
	 * 根據分公司代號及群組Pk查詢約定帳號
	 * @param securitiesNo
	 * @param groupPk
	 * @param bankBracnchNo TODO
	 * @return
	 */
	public PreDesignatedAccount getPreDesignatedAccountBySecuritiesNoAndGroupPk(String securitiesNo, Long groupPk, String bankBracnchNo);
	
	/**
	 * 新增券商約定帳號
	 * @return
	 */
	public int insert(PreDesignatedAccount preDesignatedAccount);
	
	/**
	 * 更新券商約定帳號
	 * @param preDesignatedAccountPk 更新前券商約定帳號資料的主鍵 
	 * @param auditEntity 更新者的相關信息
	 * @return
	 */
	public int update(Long preDesignatedAccountPk,AuditEntity auditEntity);
}
